package top.infopub.model.bpa;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BusinessPaymentSettleExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BusinessPaymentSettleExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.isEmpty()) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria();
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return !criteria.isEmpty();
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value) {
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2) {
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andSguidIsNull() {
            addCriterion("SGUID is null");
            return (Criteria) this;
        }

        public Criteria andSguidIsNotNull() {
            addCriterion("SGUID is not null");
            return (Criteria) this;
        }

        public Criteria andSguidEqualTo(String value) {
            addCriterion("SGUID =", value);
            return (Criteria) this;
        }

        public Criteria andSguidNotEqualTo(String value) {
            addCriterion("SGUID <>", value);
            return (Criteria) this;
        }

        public Criteria andSguidGreaterThan(String value) {
            addCriterion("SGUID >", value);
            return (Criteria) this;
        }

        public Criteria andSguidGreaterThanOrEqualTo(String value) {
            addCriterion("SGUID >=", value);
            return (Criteria) this;
        }

        public Criteria andSguidLessThan(String value) {
            addCriterion("SGUID <", value);
            return (Criteria) this;
        }

        public Criteria andSguidLessThanOrEqualTo(String value) {
            addCriterion("SGUID <=", value);
            return (Criteria) this;
        }

        public Criteria andSguidLike(String value) {
            addCriterion("SGUID like", value);
            return (Criteria) this;
        }

        public Criteria andSguidNotLike(String value) {
            addCriterion("SGUID not like", value);
            return (Criteria) this;
        }

        public Criteria andSguidIn(List<String> values) {
            addCriterion("SGUID in", values);
            return (Criteria) this;
        }

        public Criteria andSguidNotIn(List<String> values) {
            addCriterion("SGUID not in", values);
            return (Criteria) this;
        }

        public Criteria andSguidBetween(String value1, String value2) {
            addCriterion("SGUID between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andSguidNotBetween(String value1, String value2) {
            addCriterion("SGUID not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCodesIsNull() {
            addCriterion("CODES is null");
            return (Criteria) this;
        }

        public Criteria andCodesIsNotNull() {
            addCriterion("CODES is not null");
            return (Criteria) this;
        }

        public Criteria andCodesEqualTo(String value) {
            addCriterion("CODES =", value);
            return (Criteria) this;
        }

        public Criteria andCodesNotEqualTo(String value) {
            addCriterion("CODES <>", value);
            return (Criteria) this;
        }

        public Criteria andCodesGreaterThan(String value) {
            addCriterion("CODES >", value);
            return (Criteria) this;
        }

        public Criteria andCodesGreaterThanOrEqualTo(String value) {
            addCriterion("CODES >=", value);
            return (Criteria) this;
        }

        public Criteria andCodesLessThan(String value) {
            addCriterion("CODES <", value);
            return (Criteria) this;
        }

        public Criteria andCodesLessThanOrEqualTo(String value) {
            addCriterion("CODES <=", value);
            return (Criteria) this;
        }

        public Criteria andCodesLike(String value) {
            addCriterion("CODES like", value);
            return (Criteria) this;
        }

        public Criteria andCodesNotLike(String value) {
            addCriterion("CODES not like", value);
            return (Criteria) this;
        }

        public Criteria andCodesIn(List<String> values) {
            addCriterion("CODES in", values);
            return (Criteria) this;
        }

        public Criteria andCodesNotIn(List<String> values) {
            addCriterion("CODES not in", values);
            return (Criteria) this;
        }

        public Criteria andCodesBetween(String value1, String value2) {
            addCriterion("CODES between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCodesNotBetween(String value1, String value2) {
            addCriterion("CODES not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNull() {
            addCriterion("PAYMENT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNotNull() {
            addCriterion("PAYMENT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeEqualTo(String value) {
            addCriterion("PAYMENT_TYPE =", value);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotEqualTo(String value) {
            addCriterion("PAYMENT_TYPE <>", value);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThan(String value) {
            addCriterion("PAYMENT_TYPE >", value);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYMENT_TYPE >=", value);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThan(String value) {
            addCriterion("PAYMENT_TYPE <", value);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThanOrEqualTo(String value) {
            addCriterion("PAYMENT_TYPE <=", value);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLike(String value) {
            addCriterion("PAYMENT_TYPE like", value);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotLike(String value) {
            addCriterion("PAYMENT_TYPE not like", value);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIn(List<String> values) {
            addCriterion("PAYMENT_TYPE in", values);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotIn(List<String> values) {
            addCriterion("PAYMENT_TYPE not in", values);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeBetween(String value1, String value2) {
            addCriterion("PAYMENT_TYPE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotBetween(String value1, String value2) {
            addCriterion("PAYMENT_TYPE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andContractAmountIsNull() {
            addCriterion("CONTRACT_AMOUNT is null");
            return (Criteria) this;
        }

        public Criteria andContractAmountIsNotNull() {
            addCriterion("CONTRACT_AMOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andContractAmountEqualTo(Long value) {
            addCriterion("CONTRACT_AMOUNT =", value);
            return (Criteria) this;
        }

        public Criteria andContractAmountNotEqualTo(Long value) {
            addCriterion("CONTRACT_AMOUNT <>", value);
            return (Criteria) this;
        }

        public Criteria andContractAmountGreaterThan(Long value) {
            addCriterion("CONTRACT_AMOUNT >", value);
            return (Criteria) this;
        }

        public Criteria andContractAmountGreaterThanOrEqualTo(Long value) {
            addCriterion("CONTRACT_AMOUNT >=", value);
            return (Criteria) this;
        }

        public Criteria andContractAmountLessThan(Long value) {
            addCriterion("CONTRACT_AMOUNT <", value);
            return (Criteria) this;
        }

        public Criteria andContractAmountLessThanOrEqualTo(Long value) {
            addCriterion("CONTRACT_AMOUNT <=", value);
            return (Criteria) this;
        }

        public Criteria andContractAmountIn(List<Long> values) {
            addCriterion("CONTRACT_AMOUNT in", values);
            return (Criteria) this;
        }

        public Criteria andContractAmountNotIn(List<Long> values) {
            addCriterion("CONTRACT_AMOUNT not in", values);
            return (Criteria) this;
        }

        public Criteria andContractAmountBetween(Long value1, Long value2) {
            addCriterion("CONTRACT_AMOUNT between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andContractAmountNotBetween(Long value1, Long value2) {
            addCriterion("CONTRACT_AMOUNT not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateIsNull() {
            addCriterion("ADVANCE_CHARGE_RATE is null");
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateIsNotNull() {
            addCriterion("ADVANCE_CHARGE_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateEqualTo(String value) {
            addCriterion("ADVANCE_CHARGE_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateNotEqualTo(String value) {
            addCriterion("ADVANCE_CHARGE_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateGreaterThan(String value) {
            addCriterion("ADVANCE_CHARGE_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateGreaterThanOrEqualTo(String value) {
            addCriterion("ADVANCE_CHARGE_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateLessThan(String value) {
            addCriterion("ADVANCE_CHARGE_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateLessThanOrEqualTo(String value) {
            addCriterion("ADVANCE_CHARGE_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateLike(String value) {
            addCriterion("ADVANCE_CHARGE_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateNotLike(String value) {
            addCriterion("ADVANCE_CHARGE_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateIn(List<String> values) {
            addCriterion("ADVANCE_CHARGE_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateNotIn(List<String> values) {
            addCriterion("ADVANCE_CHARGE_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateBetween(String value1, String value2) {
            addCriterion("ADVANCE_CHARGE_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAdvanceChargeRateNotBetween(String value1, String value2) {
            addCriterion("ADVANCE_CHARGE_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeIsNull() {
            addCriterion("PAYABLE_ADVANCE_CHARGE is null");
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeIsNotNull() {
            addCriterion("PAYABLE_ADVANCE_CHARGE is not null");
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeEqualTo(Long value) {
            addCriterion("PAYABLE_ADVANCE_CHARGE =", value);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeNotEqualTo(Long value) {
            addCriterion("PAYABLE_ADVANCE_CHARGE <>", value);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeGreaterThan(Long value) {
            addCriterion("PAYABLE_ADVANCE_CHARGE >", value);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeGreaterThanOrEqualTo(Long value) {
            addCriterion("PAYABLE_ADVANCE_CHARGE >=", value);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeLessThan(Long value) {
            addCriterion("PAYABLE_ADVANCE_CHARGE <", value);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeLessThanOrEqualTo(Long value) {
            addCriterion("PAYABLE_ADVANCE_CHARGE <=", value);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeIn(List<Long> values) {
            addCriterion("PAYABLE_ADVANCE_CHARGE in", values);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeNotIn(List<Long> values) {
            addCriterion("PAYABLE_ADVANCE_CHARGE not in", values);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeBetween(Long value1, Long value2) {
            addCriterion("PAYABLE_ADVANCE_CHARGE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPayableAdvanceChargeNotBetween(Long value1, Long value2) {
            addCriterion("PAYABLE_ADVANCE_CHARGE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableIsNull() {
            addCriterion("CUMULATIVE_PAYABLE is null");
            return (Criteria) this;
        }

        public Criteria andCumulativePayableIsNotNull() {
            addCriterion("CUMULATIVE_PAYABLE is not null");
            return (Criteria) this;
        }

        public Criteria andCumulativePayableEqualTo(Long value) {
            addCriterion("CUMULATIVE_PAYABLE =", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableNotEqualTo(Long value) {
            addCriterion("CUMULATIVE_PAYABLE <>", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableGreaterThan(Long value) {
            addCriterion("CUMULATIVE_PAYABLE >", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableGreaterThanOrEqualTo(Long value) {
            addCriterion("CUMULATIVE_PAYABLE >=", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableLessThan(Long value) {
            addCriterion("CUMULATIVE_PAYABLE <", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableLessThanOrEqualTo(Long value) {
            addCriterion("CUMULATIVE_PAYABLE <=", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableIn(List<Long> values) {
            addCriterion("CUMULATIVE_PAYABLE in", values);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableNotIn(List<Long> values) {
            addCriterion("CUMULATIVE_PAYABLE not in", values);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableBetween(Long value1, Long value2) {
            addCriterion("CUMULATIVE_PAYABLE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCumulativePayableNotBetween(Long value1, Long value2) {
            addCriterion("CUMULATIVE_PAYABLE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidIsNull() {
            addCriterion("CUMULATIVE_PAID is null");
            return (Criteria) this;
        }

        public Criteria andCumulativePaidIsNotNull() {
            addCriterion("CUMULATIVE_PAID is not null");
            return (Criteria) this;
        }

        public Criteria andCumulativePaidEqualTo(Long value) {
            addCriterion("CUMULATIVE_PAID =", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidNotEqualTo(Long value) {
            addCriterion("CUMULATIVE_PAID <>", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidGreaterThan(Long value) {
            addCriterion("CUMULATIVE_PAID >", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidGreaterThanOrEqualTo(Long value) {
            addCriterion("CUMULATIVE_PAID >=", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidLessThan(Long value) {
            addCriterion("CUMULATIVE_PAID <", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidLessThanOrEqualTo(Long value) {
            addCriterion("CUMULATIVE_PAID <=", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidIn(List<Long> values) {
            addCriterion("CUMULATIVE_PAID in", values);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidNotIn(List<Long> values) {
            addCriterion("CUMULATIVE_PAID not in", values);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidBetween(Long value1, Long value2) {
            addCriterion("CUMULATIVE_PAID between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCumulativePaidNotBetween(Long value1, Long value2) {
            addCriterion("CUMULATIVE_PAID not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtIsNull() {
            addCriterion("PREVIOUS_DEBT is null");
            return (Criteria) this;
        }

        public Criteria andPreviousDebtIsNotNull() {
            addCriterion("PREVIOUS_DEBT is not null");
            return (Criteria) this;
        }

        public Criteria andPreviousDebtEqualTo(Long value) {
            addCriterion("PREVIOUS_DEBT =", value);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtNotEqualTo(Long value) {
            addCriterion("PREVIOUS_DEBT <>", value);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtGreaterThan(Long value) {
            addCriterion("PREVIOUS_DEBT >", value);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtGreaterThanOrEqualTo(Long value) {
            addCriterion("PREVIOUS_DEBT >=", value);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtLessThan(Long value) {
            addCriterion("PREVIOUS_DEBT <", value);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtLessThanOrEqualTo(Long value) {
            addCriterion("PREVIOUS_DEBT <=", value);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtIn(List<Long> values) {
            addCriterion("PREVIOUS_DEBT in", values);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtNotIn(List<Long> values) {
            addCriterion("PREVIOUS_DEBT not in", values);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtBetween(Long value1, Long value2) {
            addCriterion("PREVIOUS_DEBT between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPreviousDebtNotBetween(Long value1, Long value2) {
            addCriterion("PREVIOUS_DEBT not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyIsNull() {
            addCriterion("PAYABLE_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyIsNotNull() {
            addCriterion("PAYABLE_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andPayableMoneyEqualTo(Long value) {
            addCriterion("PAYABLE_MONEY =", value);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyNotEqualTo(Long value) {
            addCriterion("PAYABLE_MONEY <>", value);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyGreaterThan(Long value) {
            addCriterion("PAYABLE_MONEY >", value);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("PAYABLE_MONEY >=", value);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyLessThan(Long value) {
            addCriterion("PAYABLE_MONEY <", value);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyLessThanOrEqualTo(Long value) {
            addCriterion("PAYABLE_MONEY <=", value);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyIn(List<Long> values) {
            addCriterion("PAYABLE_MONEY in", values);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyNotIn(List<Long> values) {
            addCriterion("PAYABLE_MONEY not in", values);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyBetween(Long value1, Long value2) {
            addCriterion("PAYABLE_MONEY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPayableMoneyNotBetween(Long value1, Long value2) {
            addCriterion("PAYABLE_MONEY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyIsNull() {
            addCriterion("CONFIRMED_PROPERTY is null");
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyIsNotNull() {
            addCriterion("CONFIRMED_PROPERTY is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyEqualTo(Long value) {
            addCriterion("CONFIRMED_PROPERTY =", value);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyNotEqualTo(Long value) {
            addCriterion("CONFIRMED_PROPERTY <>", value);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyGreaterThan(Long value) {
            addCriterion("CONFIRMED_PROPERTY >", value);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyGreaterThanOrEqualTo(Long value) {
            addCriterion("CONFIRMED_PROPERTY >=", value);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyLessThan(Long value) {
            addCriterion("CONFIRMED_PROPERTY <", value);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyLessThanOrEqualTo(Long value) {
            addCriterion("CONFIRMED_PROPERTY <=", value);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyIn(List<Long> values) {
            addCriterion("CONFIRMED_PROPERTY in", values);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyNotIn(List<Long> values) {
            addCriterion("CONFIRMED_PROPERTY not in", values);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyBetween(Long value1, Long value2) {
            addCriterion("CONFIRMED_PROPERTY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andConfirmedPropertyNotBetween(Long value1, Long value2) {
            addCriterion("CONFIRMED_PROPERTY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateIsNull() {
            addCriterion("MONTHLY_PAYMENT_RATE is null");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateIsNotNull() {
            addCriterion("MONTHLY_PAYMENT_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateEqualTo(String value) {
            addCriterion("MONTHLY_PAYMENT_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateNotEqualTo(String value) {
            addCriterion("MONTHLY_PAYMENT_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateGreaterThan(String value) {
            addCriterion("MONTHLY_PAYMENT_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateGreaterThanOrEqualTo(String value) {
            addCriterion("MONTHLY_PAYMENT_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateLessThan(String value) {
            addCriterion("MONTHLY_PAYMENT_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateLessThanOrEqualTo(String value) {
            addCriterion("MONTHLY_PAYMENT_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateLike(String value) {
            addCriterion("MONTHLY_PAYMENT_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateNotLike(String value) {
            addCriterion("MONTHLY_PAYMENT_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateIn(List<String> values) {
            addCriterion("MONTHLY_PAYMENT_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateNotIn(List<String> values) {
            addCriterion("MONTHLY_PAYMENT_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateBetween(String value1, String value2) {
            addCriterion("MONTHLY_PAYMENT_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentRateNotBetween(String value1, String value2) {
            addCriterion("MONTHLY_PAYMENT_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateIsNull() {
            addCriterion("SYNTHESIZE_ADJUST_RATE is null");
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateIsNotNull() {
            addCriterion("SYNTHESIZE_ADJUST_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateEqualTo(String value) {
            addCriterion("SYNTHESIZE_ADJUST_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateNotEqualTo(String value) {
            addCriterion("SYNTHESIZE_ADJUST_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateGreaterThan(String value) {
            addCriterion("SYNTHESIZE_ADJUST_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateGreaterThanOrEqualTo(String value) {
            addCriterion("SYNTHESIZE_ADJUST_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateLessThan(String value) {
            addCriterion("SYNTHESIZE_ADJUST_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateLessThanOrEqualTo(String value) {
            addCriterion("SYNTHESIZE_ADJUST_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateLike(String value) {
            addCriterion("SYNTHESIZE_ADJUST_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateNotLike(String value) {
            addCriterion("SYNTHESIZE_ADJUST_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateIn(List<String> values) {
            addCriterion("SYNTHESIZE_ADJUST_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateNotIn(List<String> values) {
            addCriterion("SYNTHESIZE_ADJUST_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateBetween(String value1, String value2) {
            addCriterion("SYNTHESIZE_ADJUST_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andSynthesizeAdjustRateNotBetween(String value1, String value2) {
            addCriterion("SYNTHESIZE_ADJUST_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateIsNull() {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE is null");
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateIsNotNull() {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateEqualTo(String value) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateNotEqualTo(String value) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateGreaterThan(String value) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateGreaterThanOrEqualTo(String value) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateLessThan(String value) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateLessThanOrEqualTo(String value) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateLike(String value) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateNotLike(String value) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateIn(List<String> values) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateNotIn(List<String> values) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateBetween(String value1, String value2) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualPayRateNotBetween(String value1, String value2) {
            addCriterion("MONTHLY_ACTUAL_PAY_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyIsNull() {
            addCriterion("MONTHLY_PAYABLE_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyIsNotNull() {
            addCriterion("MONTHLY_PAYABLE_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyEqualTo(Long value) {
            addCriterion("MONTHLY_PAYABLE_MONEY =", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyNotEqualTo(Long value) {
            addCriterion("MONTHLY_PAYABLE_MONEY <>", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyGreaterThan(Long value) {
            addCriterion("MONTHLY_PAYABLE_MONEY >", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("MONTHLY_PAYABLE_MONEY >=", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyLessThan(Long value) {
            addCriterion("MONTHLY_PAYABLE_MONEY <", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyLessThanOrEqualTo(Long value) {
            addCriterion("MONTHLY_PAYABLE_MONEY <=", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyIn(List<Long> values) {
            addCriterion("MONTHLY_PAYABLE_MONEY in", values);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyNotIn(List<Long> values) {
            addCriterion("MONTHLY_PAYABLE_MONEY not in", values);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyBetween(Long value1, Long value2) {
            addCriterion("MONTHLY_PAYABLE_MONEY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andMonthlyPayableMoneyNotBetween(Long value1, Long value2) {
            addCriterion("MONTHLY_PAYABLE_MONEY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyIsNull() {
            addCriterion("INC_DEC_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyIsNotNull() {
            addCriterion("INC_DEC_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyEqualTo(Long value) {
            addCriterion("INC_DEC_MONEY =", value);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyNotEqualTo(Long value) {
            addCriterion("INC_DEC_MONEY <>", value);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyGreaterThan(Long value) {
            addCriterion("INC_DEC_MONEY >", value);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("INC_DEC_MONEY >=", value);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyLessThan(Long value) {
            addCriterion("INC_DEC_MONEY <", value);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyLessThanOrEqualTo(Long value) {
            addCriterion("INC_DEC_MONEY <=", value);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyIn(List<Long> values) {
            addCriterion("INC_DEC_MONEY in", values);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyNotIn(List<Long> values) {
            addCriterion("INC_DEC_MONEY not in", values);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyBetween(Long value1, Long value2) {
            addCriterion("INC_DEC_MONEY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andIncDecMoneyNotBetween(Long value1, Long value2) {
            addCriterion("INC_DEC_MONEY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyIsNull() {
            addCriterion("MONTHLY_ACTUAL_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyIsNotNull() {
            addCriterion("MONTHLY_ACTUAL_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyEqualTo(Long value) {
            addCriterion("MONTHLY_ACTUAL_MONEY =", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyNotEqualTo(Long value) {
            addCriterion("MONTHLY_ACTUAL_MONEY <>", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyGreaterThan(Long value) {
            addCriterion("MONTHLY_ACTUAL_MONEY >", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("MONTHLY_ACTUAL_MONEY >=", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyLessThan(Long value) {
            addCriterion("MONTHLY_ACTUAL_MONEY <", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyLessThanOrEqualTo(Long value) {
            addCriterion("MONTHLY_ACTUAL_MONEY <=", value);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyIn(List<Long> values) {
            addCriterion("MONTHLY_ACTUAL_MONEY in", values);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyNotIn(List<Long> values) {
            addCriterion("MONTHLY_ACTUAL_MONEY not in", values);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyBetween(Long value1, Long value2) {
            addCriterion("MONTHLY_ACTUAL_MONEY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andMonthlyActualMoneyNotBetween(Long value1, Long value2) {
            addCriterion("MONTHLY_ACTUAL_MONEY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginIsNull() {
            addCriterion("YEAR_PAYMENT_BEGIN is null");
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginIsNotNull() {
            addCriterion("YEAR_PAYMENT_BEGIN is not null");
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginEqualTo(Date value) {
            addCriterion("YEAR_PAYMENT_BEGIN =", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginNotEqualTo(Date value) {
            addCriterion("YEAR_PAYMENT_BEGIN <>", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginGreaterThan(Date value) {
            addCriterion("YEAR_PAYMENT_BEGIN >", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginGreaterThanOrEqualTo(Date value) {
            addCriterion("YEAR_PAYMENT_BEGIN >=", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginLessThan(Date value) {
            addCriterion("YEAR_PAYMENT_BEGIN <", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginLessThanOrEqualTo(Date value) {
            addCriterion("YEAR_PAYMENT_BEGIN <=", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginIn(List<Date> values) {
            addCriterion("YEAR_PAYMENT_BEGIN in", values);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginNotIn(List<Date> values) {
            addCriterion("YEAR_PAYMENT_BEGIN not in", values);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginBetween(Date value1, Date value2) {
            addCriterion("YEAR_PAYMENT_BEGIN between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPaymentBeginNotBetween(Date value1, Date value2) {
            addCriterion("YEAR_PAYMENT_BEGIN not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndIsNull() {
            addCriterion("YEAR_PAYMENT_END is null");
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndIsNotNull() {
            addCriterion("YEAR_PAYMENT_END is not null");
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndEqualTo(Date value) {
            addCriterion("YEAR_PAYMENT_END =", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndNotEqualTo(Date value) {
            addCriterion("YEAR_PAYMENT_END <>", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndGreaterThan(Date value) {
            addCriterion("YEAR_PAYMENT_END >", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndGreaterThanOrEqualTo(Date value) {
            addCriterion("YEAR_PAYMENT_END >=", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndLessThan(Date value) {
            addCriterion("YEAR_PAYMENT_END <", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndLessThanOrEqualTo(Date value) {
            addCriterion("YEAR_PAYMENT_END <=", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndIn(List<Date> values) {
            addCriterion("YEAR_PAYMENT_END in", values);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndNotIn(List<Date> values) {
            addCriterion("YEAR_PAYMENT_END not in", values);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndBetween(Date value1, Date value2) {
            addCriterion("YEAR_PAYMENT_END between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPaymentEndNotBetween(Date value1, Date value2) {
            addCriterion("YEAR_PAYMENT_END not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPropertyIsNull() {
            addCriterion("YEAR_PROPERTY is null");
            return (Criteria) this;
        }

        public Criteria andYearPropertyIsNotNull() {
            addCriterion("YEAR_PROPERTY is not null");
            return (Criteria) this;
        }

        public Criteria andYearPropertyEqualTo(Long value) {
            addCriterion("YEAR_PROPERTY =", value);
            return (Criteria) this;
        }

        public Criteria andYearPropertyNotEqualTo(Long value) {
            addCriterion("YEAR_PROPERTY <>", value);
            return (Criteria) this;
        }

        public Criteria andYearPropertyGreaterThan(Long value) {
            addCriterion("YEAR_PROPERTY >", value);
            return (Criteria) this;
        }

        public Criteria andYearPropertyGreaterThanOrEqualTo(Long value) {
            addCriterion("YEAR_PROPERTY >=", value);
            return (Criteria) this;
        }

        public Criteria andYearPropertyLessThan(Long value) {
            addCriterion("YEAR_PROPERTY <", value);
            return (Criteria) this;
        }

        public Criteria andYearPropertyLessThanOrEqualTo(Long value) {
            addCriterion("YEAR_PROPERTY <=", value);
            return (Criteria) this;
        }

        public Criteria andYearPropertyIn(List<Long> values) {
            addCriterion("YEAR_PROPERTY in", values);
            return (Criteria) this;
        }

        public Criteria andYearPropertyNotIn(List<Long> values) {
            addCriterion("YEAR_PROPERTY not in", values);
            return (Criteria) this;
        }

        public Criteria andYearPropertyBetween(Long value1, Long value2) {
            addCriterion("YEAR_PROPERTY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPropertyNotBetween(Long value1, Long value2) {
            addCriterion("YEAR_PROPERTY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateIsNull() {
            addCriterion("YEAR_PAYMENT_RATE is null");
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateIsNotNull() {
            addCriterion("YEAR_PAYMENT_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateEqualTo(String value) {
            addCriterion("YEAR_PAYMENT_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateNotEqualTo(String value) {
            addCriterion("YEAR_PAYMENT_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateGreaterThan(String value) {
            addCriterion("YEAR_PAYMENT_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateGreaterThanOrEqualTo(String value) {
            addCriterion("YEAR_PAYMENT_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateLessThan(String value) {
            addCriterion("YEAR_PAYMENT_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateLessThanOrEqualTo(String value) {
            addCriterion("YEAR_PAYMENT_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateLike(String value) {
            addCriterion("YEAR_PAYMENT_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateNotLike(String value) {
            addCriterion("YEAR_PAYMENT_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateIn(List<String> values) {
            addCriterion("YEAR_PAYMENT_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateNotIn(List<String> values) {
            addCriterion("YEAR_PAYMENT_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateBetween(String value1, String value2) {
            addCriterion("YEAR_PAYMENT_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPaymentRateNotBetween(String value1, String value2) {
            addCriterion("YEAR_PAYMENT_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyIsNull() {
            addCriterion("YEAR_PAYABLE_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyIsNotNull() {
            addCriterion("YEAR_PAYABLE_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyEqualTo(Long value) {
            addCriterion("YEAR_PAYABLE_MONEY =", value);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyNotEqualTo(Long value) {
            addCriterion("YEAR_PAYABLE_MONEY <>", value);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyGreaterThan(Long value) {
            addCriterion("YEAR_PAYABLE_MONEY >", value);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("YEAR_PAYABLE_MONEY >=", value);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyLessThan(Long value) {
            addCriterion("YEAR_PAYABLE_MONEY <", value);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyLessThanOrEqualTo(Long value) {
            addCriterion("YEAR_PAYABLE_MONEY <=", value);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyIn(List<Long> values) {
            addCriterion("YEAR_PAYABLE_MONEY in", values);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyNotIn(List<Long> values) {
            addCriterion("YEAR_PAYABLE_MONEY not in", values);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyBetween(Long value1, Long value2) {
            addCriterion("YEAR_PAYABLE_MONEY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearPayableMoneyNotBetween(Long value1, Long value2) {
            addCriterion("YEAR_PAYABLE_MONEY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyIsNull() {
            addCriterion("YEAR_ACTUAL_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyIsNotNull() {
            addCriterion("YEAR_ACTUAL_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyEqualTo(Long value) {
            addCriterion("YEAR_ACTUAL_MONEY =", value);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyNotEqualTo(Long value) {
            addCriterion("YEAR_ACTUAL_MONEY <>", value);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyGreaterThan(Long value) {
            addCriterion("YEAR_ACTUAL_MONEY >", value);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("YEAR_ACTUAL_MONEY >=", value);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyLessThan(Long value) {
            addCriterion("YEAR_ACTUAL_MONEY <", value);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyLessThanOrEqualTo(Long value) {
            addCriterion("YEAR_ACTUAL_MONEY <=", value);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyIn(List<Long> values) {
            addCriterion("YEAR_ACTUAL_MONEY in", values);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyNotIn(List<Long> values) {
            addCriterion("YEAR_ACTUAL_MONEY not in", values);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyBetween(Long value1, Long value2) {
            addCriterion("YEAR_ACTUAL_MONEY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andYearActualMoneyNotBetween(Long value1, Long value2) {
            addCriterion("YEAR_ACTUAL_MONEY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyIsNull() {
            addCriterion("CUMULATIVE_PROPERTY is null");
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyIsNotNull() {
            addCriterion("CUMULATIVE_PROPERTY is not null");
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyEqualTo(Long value) {
            addCriterion("CUMULATIVE_PROPERTY =", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyNotEqualTo(Long value) {
            addCriterion("CUMULATIVE_PROPERTY <>", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyGreaterThan(Long value) {
            addCriterion("CUMULATIVE_PROPERTY >", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyGreaterThanOrEqualTo(Long value) {
            addCriterion("CUMULATIVE_PROPERTY >=", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyLessThan(Long value) {
            addCriterion("CUMULATIVE_PROPERTY <", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyLessThanOrEqualTo(Long value) {
            addCriterion("CUMULATIVE_PROPERTY <=", value);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyIn(List<Long> values) {
            addCriterion("CUMULATIVE_PROPERTY in", values);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyNotIn(List<Long> values) {
            addCriterion("CUMULATIVE_PROPERTY not in", values);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyBetween(Long value1, Long value2) {
            addCriterion("CUMULATIVE_PROPERTY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCumulativePropertyNotBetween(Long value1, Long value2) {
            addCriterion("CUMULATIVE_PROPERTY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateIsNull() {
            addCriterion("COMPLETED_PAY_RATE is null");
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateIsNotNull() {
            addCriterion("COMPLETED_PAY_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateEqualTo(String value) {
            addCriterion("COMPLETED_PAY_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateNotEqualTo(String value) {
            addCriterion("COMPLETED_PAY_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateGreaterThan(String value) {
            addCriterion("COMPLETED_PAY_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateGreaterThanOrEqualTo(String value) {
            addCriterion("COMPLETED_PAY_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateLessThan(String value) {
            addCriterion("COMPLETED_PAY_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateLessThanOrEqualTo(String value) {
            addCriterion("COMPLETED_PAY_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateLike(String value) {
            addCriterion("COMPLETED_PAY_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateNotLike(String value) {
            addCriterion("COMPLETED_PAY_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateIn(List<String> values) {
            addCriterion("COMPLETED_PAY_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateNotIn(List<String> values) {
            addCriterion("COMPLETED_PAY_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateBetween(String value1, String value2) {
            addCriterion("COMPLETED_PAY_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCompletedPayRateNotBetween(String value1, String value2) {
            addCriterion("COMPLETED_PAY_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyIsNull() {
            addCriterion("COMPLETED_PAYABLE_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyIsNotNull() {
            addCriterion("COMPLETED_PAYABLE_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyEqualTo(Long value) {
            addCriterion("COMPLETED_PAYABLE_MONEY =", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyNotEqualTo(Long value) {
            addCriterion("COMPLETED_PAYABLE_MONEY <>", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyGreaterThan(Long value) {
            addCriterion("COMPLETED_PAYABLE_MONEY >", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("COMPLETED_PAYABLE_MONEY >=", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyLessThan(Long value) {
            addCriterion("COMPLETED_PAYABLE_MONEY <", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyLessThanOrEqualTo(Long value) {
            addCriterion("COMPLETED_PAYABLE_MONEY <=", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyIn(List<Long> values) {
            addCriterion("COMPLETED_PAYABLE_MONEY in", values);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyNotIn(List<Long> values) {
            addCriterion("COMPLETED_PAYABLE_MONEY not in", values);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyBetween(Long value1, Long value2) {
            addCriterion("COMPLETED_PAYABLE_MONEY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableMoneyNotBetween(Long value1, Long value2) {
            addCriterion("COMPLETED_PAYABLE_MONEY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountIsNull() {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountIsNotNull() {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountEqualTo(Long value) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT =", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountNotEqualTo(Long value) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT <>", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountGreaterThan(Long value) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT >", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountGreaterThanOrEqualTo(Long value) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT >=", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountLessThan(Long value) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT <", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountLessThanOrEqualTo(Long value) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT <=", value);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountIn(List<Long> values) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT in", values);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountNotIn(List<Long> values) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT not in", values);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountBetween(Long value1, Long value2) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCompletedPayableAccountNotBetween(Long value1, Long value2) {
            addCriterion("COMPLETED_PAYABLE_ACCOUNT not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceIsNull() {
            addCriterion("PROJECT_SETTLE_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceIsNotNull() {
            addCriterion("PROJECT_SETTLE_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceEqualTo(Long value) {
            addCriterion("PROJECT_SETTLE_PRICE =", value);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceNotEqualTo(Long value) {
            addCriterion("PROJECT_SETTLE_PRICE <>", value);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceGreaterThan(Long value) {
            addCriterion("PROJECT_SETTLE_PRICE >", value);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceGreaterThanOrEqualTo(Long value) {
            addCriterion("PROJECT_SETTLE_PRICE >=", value);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceLessThan(Long value) {
            addCriterion("PROJECT_SETTLE_PRICE <", value);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceLessThanOrEqualTo(Long value) {
            addCriterion("PROJECT_SETTLE_PRICE <=", value);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceIn(List<Long> values) {
            addCriterion("PROJECT_SETTLE_PRICE in", values);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceNotIn(List<Long> values) {
            addCriterion("PROJECT_SETTLE_PRICE not in", values);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceBetween(Long value1, Long value2) {
            addCriterion("PROJECT_SETTLE_PRICE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andProjectSettlePriceNotBetween(Long value1, Long value2) {
            addCriterion("PROJECT_SETTLE_PRICE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateIsNull() {
            addCriterion("SETTLE_PAY_RATE is null");
            return (Criteria) this;
        }

        public Criteria andSettlePayRateIsNotNull() {
            addCriterion("SETTLE_PAY_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andSettlePayRateEqualTo(String value) {
            addCriterion("SETTLE_PAY_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateNotEqualTo(String value) {
            addCriterion("SETTLE_PAY_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateGreaterThan(String value) {
            addCriterion("SETTLE_PAY_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateGreaterThanOrEqualTo(String value) {
            addCriterion("SETTLE_PAY_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateLessThan(String value) {
            addCriterion("SETTLE_PAY_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateLessThanOrEqualTo(String value) {
            addCriterion("SETTLE_PAY_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateLike(String value) {
            addCriterion("SETTLE_PAY_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateNotLike(String value) {
            addCriterion("SETTLE_PAY_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateIn(List<String> values) {
            addCriterion("SETTLE_PAY_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateNotIn(List<String> values) {
            addCriterion("SETTLE_PAY_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateBetween(String value1, String value2) {
            addCriterion("SETTLE_PAY_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andSettlePayRateNotBetween(String value1, String value2) {
            addCriterion("SETTLE_PAY_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDuesIsNull() {
            addCriterion("DUES is null");
            return (Criteria) this;
        }

        public Criteria andDuesIsNotNull() {
            addCriterion("DUES is not null");
            return (Criteria) this;
        }

        public Criteria andDuesEqualTo(Long value) {
            addCriterion("DUES =", value);
            return (Criteria) this;
        }

        public Criteria andDuesNotEqualTo(Long value) {
            addCriterion("DUES <>", value);
            return (Criteria) this;
        }

        public Criteria andDuesGreaterThan(Long value) {
            addCriterion("DUES >", value);
            return (Criteria) this;
        }

        public Criteria andDuesGreaterThanOrEqualTo(Long value) {
            addCriterion("DUES >=", value);
            return (Criteria) this;
        }

        public Criteria andDuesLessThan(Long value) {
            addCriterion("DUES <", value);
            return (Criteria) this;
        }

        public Criteria andDuesLessThanOrEqualTo(Long value) {
            addCriterion("DUES <=", value);
            return (Criteria) this;
        }

        public Criteria andDuesIn(List<Long> values) {
            addCriterion("DUES in", values);
            return (Criteria) this;
        }

        public Criteria andDuesNotIn(List<Long> values) {
            addCriterion("DUES not in", values);
            return (Criteria) this;
        }

        public Criteria andDuesBetween(Long value1, Long value2) {
            addCriterion("DUES between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDuesNotBetween(Long value1, Long value2) {
            addCriterion("DUES not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andSettleDuesIsNull() {
            addCriterion("SETTLE_DUES is null");
            return (Criteria) this;
        }

        public Criteria andSettleDuesIsNotNull() {
            addCriterion("SETTLE_DUES is not null");
            return (Criteria) this;
        }

        public Criteria andSettleDuesEqualTo(Long value) {
            addCriterion("SETTLE_DUES =", value);
            return (Criteria) this;
        }

        public Criteria andSettleDuesNotEqualTo(Long value) {
            addCriterion("SETTLE_DUES <>", value);
            return (Criteria) this;
        }

        public Criteria andSettleDuesGreaterThan(Long value) {
            addCriterion("SETTLE_DUES >", value);
            return (Criteria) this;
        }

        public Criteria andSettleDuesGreaterThanOrEqualTo(Long value) {
            addCriterion("SETTLE_DUES >=", value);
            return (Criteria) this;
        }

        public Criteria andSettleDuesLessThan(Long value) {
            addCriterion("SETTLE_DUES <", value);
            return (Criteria) this;
        }

        public Criteria andSettleDuesLessThanOrEqualTo(Long value) {
            addCriterion("SETTLE_DUES <=", value);
            return (Criteria) this;
        }

        public Criteria andSettleDuesIn(List<Long> values) {
            addCriterion("SETTLE_DUES in", values);
            return (Criteria) this;
        }

        public Criteria andSettleDuesNotIn(List<Long> values) {
            addCriterion("SETTLE_DUES not in", values);
            return (Criteria) this;
        }

        public Criteria andSettleDuesBetween(Long value1, Long value2) {
            addCriterion("SETTLE_DUES between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andSettleDuesNotBetween(Long value1, Long value2) {
            addCriterion("SETTLE_DUES not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateIsNull() {
            addCriterion("WARRANTY_DEPOSIT_RATE is null");
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateIsNotNull() {
            addCriterion("WARRANTY_DEPOSIT_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateEqualTo(String value) {
            addCriterion("WARRANTY_DEPOSIT_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateNotEqualTo(String value) {
            addCriterion("WARRANTY_DEPOSIT_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateGreaterThan(String value) {
            addCriterion("WARRANTY_DEPOSIT_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateGreaterThanOrEqualTo(String value) {
            addCriterion("WARRANTY_DEPOSIT_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateLessThan(String value) {
            addCriterion("WARRANTY_DEPOSIT_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateLessThanOrEqualTo(String value) {
            addCriterion("WARRANTY_DEPOSIT_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateLike(String value) {
            addCriterion("WARRANTY_DEPOSIT_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateNotLike(String value) {
            addCriterion("WARRANTY_DEPOSIT_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateIn(List<String> values) {
            addCriterion("WARRANTY_DEPOSIT_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateNotIn(List<String> values) {
            addCriterion("WARRANTY_DEPOSIT_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateBetween(String value1, String value2) {
            addCriterion("WARRANTY_DEPOSIT_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositRateNotBetween(String value1, String value2) {
            addCriterion("WARRANTY_DEPOSIT_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositIsNull() {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT is null");
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositIsNotNull() {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT is not null");
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositEqualTo(Long value) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT =", value);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositNotEqualTo(Long value) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT <>", value);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositGreaterThan(Long value) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT >", value);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositGreaterThanOrEqualTo(Long value) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT >=", value);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositLessThan(Long value) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT <", value);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositLessThanOrEqualTo(Long value) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT <=", value);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositIn(List<Long> values) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT in", values);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositNotIn(List<Long> values) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT not in", values);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositBetween(Long value1, Long value2) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAutualWarrantyDepositNotBetween(Long value1, Long value2) {
            addCriterion("AUTUAL_WARRANTY_DEPOSIT not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositIsNull() {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT is null");
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositIsNotNull() {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT is not null");
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositEqualTo(Long value) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT =", value);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositNotEqualTo(Long value) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT <>", value);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositGreaterThan(Long value) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT >", value);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositGreaterThanOrEqualTo(Long value) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT >=", value);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositLessThan(Long value) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT <", value);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositLessThanOrEqualTo(Long value) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT <=", value);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositIn(List<Long> values) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT in", values);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositNotIn(List<Long> values) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT not in", values);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositBetween(Long value1, Long value2) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDeductWarrantyDepositNotBetween(Long value1, Long value2) {
            addCriterion("DEDUCT_WARRANTY_DEPOSIT not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnIsNull() {
            addCriterion("WARRANTY_DEPOSIT_RETURN is null");
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnIsNotNull() {
            addCriterion("WARRANTY_DEPOSIT_RETURN is not null");
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnEqualTo(Long value) {
            addCriterion("WARRANTY_DEPOSIT_RETURN =", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnNotEqualTo(Long value) {
            addCriterion("WARRANTY_DEPOSIT_RETURN <>", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnGreaterThan(Long value) {
            addCriterion("WARRANTY_DEPOSIT_RETURN >", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnGreaterThanOrEqualTo(Long value) {
            addCriterion("WARRANTY_DEPOSIT_RETURN >=", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnLessThan(Long value) {
            addCriterion("WARRANTY_DEPOSIT_RETURN <", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnLessThanOrEqualTo(Long value) {
            addCriterion("WARRANTY_DEPOSIT_RETURN <=", value);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnIn(List<Long> values) {
            addCriterion("WARRANTY_DEPOSIT_RETURN in", values);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnNotIn(List<Long> values) {
            addCriterion("WARRANTY_DEPOSIT_RETURN not in", values);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnBetween(Long value1, Long value2) {
            addCriterion("WARRANTY_DEPOSIT_RETURN between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andWarrantyDepositReturnNotBetween(Long value1, Long value2) {
            addCriterion("WARRANTY_DEPOSIT_RETURN not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyIsNull() {
            addCriterion("DF_CONFIRMED_PROPERTY is null");
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyIsNotNull() {
            addCriterion("DF_CONFIRMED_PROPERTY is not null");
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyEqualTo(Long value) {
            addCriterion("DF_CONFIRMED_PROPERTY =", value);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyNotEqualTo(Long value) {
            addCriterion("DF_CONFIRMED_PROPERTY <>", value);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyGreaterThan(Long value) {
            addCriterion("DF_CONFIRMED_PROPERTY >", value);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyGreaterThanOrEqualTo(Long value) {
            addCriterion("DF_CONFIRMED_PROPERTY >=", value);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyLessThan(Long value) {
            addCriterion("DF_CONFIRMED_PROPERTY <", value);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyLessThanOrEqualTo(Long value) {
            addCriterion("DF_CONFIRMED_PROPERTY <=", value);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyIn(List<Long> values) {
            addCriterion("DF_CONFIRMED_PROPERTY in", values);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyNotIn(List<Long> values) {
            addCriterion("DF_CONFIRMED_PROPERTY not in", values);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyBetween(Long value1, Long value2) {
            addCriterion("DF_CONFIRMED_PROPERTY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDfConfirmedPropertyNotBetween(Long value1, Long value2) {
            addCriterion("DF_CONFIRMED_PROPERTY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDfRateIsNull() {
            addCriterion("DF_RATE is null");
            return (Criteria) this;
        }

        public Criteria andDfRateIsNotNull() {
            addCriterion("DF_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andDfRateEqualTo(String value) {
            addCriterion("DF_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andDfRateNotEqualTo(String value) {
            addCriterion("DF_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andDfRateGreaterThan(String value) {
            addCriterion("DF_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andDfRateGreaterThanOrEqualTo(String value) {
            addCriterion("DF_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andDfRateLessThan(String value) {
            addCriterion("DF_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andDfRateLessThanOrEqualTo(String value) {
            addCriterion("DF_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andDfRateLike(String value) {
            addCriterion("DF_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andDfRateNotLike(String value) {
            addCriterion("DF_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andDfRateIn(List<String> values) {
            addCriterion("DF_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andDfRateNotIn(List<String> values) {
            addCriterion("DF_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andDfRateBetween(String value1, String value2) {
            addCriterion("DF_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDfRateNotBetween(String value1, String value2) {
            addCriterion("DF_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyIsNull() {
            addCriterion("DF_PAYABLE_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyIsNotNull() {
            addCriterion("DF_PAYABLE_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyEqualTo(Long value) {
            addCriterion("DF_PAYABLE_MONEY =", value);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyNotEqualTo(Long value) {
            addCriterion("DF_PAYABLE_MONEY <>", value);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyGreaterThan(Long value) {
            addCriterion("DF_PAYABLE_MONEY >", value);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("DF_PAYABLE_MONEY >=", value);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyLessThan(Long value) {
            addCriterion("DF_PAYABLE_MONEY <", value);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyLessThanOrEqualTo(Long value) {
            addCriterion("DF_PAYABLE_MONEY <=", value);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyIn(List<Long> values) {
            addCriterion("DF_PAYABLE_MONEY in", values);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyNotIn(List<Long> values) {
            addCriterion("DF_PAYABLE_MONEY not in", values);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyBetween(Long value1, Long value2) {
            addCriterion("DF_PAYABLE_MONEY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andDfPayableMoneyNotBetween(Long value1, Long value2) {
            addCriterion("DF_PAYABLE_MONEY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyIsNull() {
            addCriterion("BEFORE_CONFIRMED_PROPERTY is null");
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyIsNotNull() {
            addCriterion("BEFORE_CONFIRMED_PROPERTY is not null");
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyEqualTo(Long value) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY =", value);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyNotEqualTo(Long value) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY <>", value);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyGreaterThan(Long value) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY >", value);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyGreaterThanOrEqualTo(Long value) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY >=", value);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyLessThan(Long value) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY <", value);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyLessThanOrEqualTo(Long value) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY <=", value);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyIn(List<Long> values) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY in", values);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyNotIn(List<Long> values) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY not in", values);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyBetween(Long value1, Long value2) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andBeforeConfirmedPropertyNotBetween(Long value1, Long value2) {
            addCriterion("BEFORE_CONFIRMED_PROPERTY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateIsNull() {
            addCriterion("APPOINT_PAY_DATE is null");
            return (Criteria) this;
        }

        public Criteria andAppointPayDateIsNotNull() {
            addCriterion("APPOINT_PAY_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andAppointPayDateEqualTo(Date value) {
            addCriterion("APPOINT_PAY_DATE =", value);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateNotEqualTo(Date value) {
            addCriterion("APPOINT_PAY_DATE <>", value);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateGreaterThan(Date value) {
            addCriterion("APPOINT_PAY_DATE >", value);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateGreaterThanOrEqualTo(Date value) {
            addCriterion("APPOINT_PAY_DATE >=", value);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateLessThan(Date value) {
            addCriterion("APPOINT_PAY_DATE <", value);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateLessThanOrEqualTo(Date value) {
            addCriterion("APPOINT_PAY_DATE <=", value);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateIn(List<Date> values) {
            addCriterion("APPOINT_PAY_DATE in", values);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateNotIn(List<Date> values) {
            addCriterion("APPOINT_PAY_DATE not in", values);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateBetween(Date value1, Date value2) {
            addCriterion("APPOINT_PAY_DATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAppointPayDateNotBetween(Date value1, Date value2) {
            addCriterion("APPOINT_PAY_DATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPayRateIsNull() {
            addCriterion("PAY_RATE is null");
            return (Criteria) this;
        }

        public Criteria andPayRateIsNotNull() {
            addCriterion("PAY_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andPayRateEqualTo(String value) {
            addCriterion("PAY_RATE =", value);
            return (Criteria) this;
        }

        public Criteria andPayRateNotEqualTo(String value) {
            addCriterion("PAY_RATE <>", value);
            return (Criteria) this;
        }

        public Criteria andPayRateGreaterThan(String value) {
            addCriterion("PAY_RATE >", value);
            return (Criteria) this;
        }

        public Criteria andPayRateGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_RATE >=", value);
            return (Criteria) this;
        }

        public Criteria andPayRateLessThan(String value) {
            addCriterion("PAY_RATE <", value);
            return (Criteria) this;
        }

        public Criteria andPayRateLessThanOrEqualTo(String value) {
            addCriterion("PAY_RATE <=", value);
            return (Criteria) this;
        }

        public Criteria andPayRateLike(String value) {
            addCriterion("PAY_RATE like", value);
            return (Criteria) this;
        }

        public Criteria andPayRateNotLike(String value) {
            addCriterion("PAY_RATE not like", value);
            return (Criteria) this;
        }

        public Criteria andPayRateIn(List<String> values) {
            addCriterion("PAY_RATE in", values);
            return (Criteria) this;
        }

        public Criteria andPayRateNotIn(List<String> values) {
            addCriterion("PAY_RATE not in", values);
            return (Criteria) this;
        }

        public Criteria andPayRateBetween(String value1, String value2) {
            addCriterion("PAY_RATE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andPayRateNotBetween(String value1, String value2) {
            addCriterion("PAY_RATE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeIsNull() {
            addCriterion("NOW_PAYABLE_BEFORE is null");
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeIsNotNull() {
            addCriterion("NOW_PAYABLE_BEFORE is not null");
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeEqualTo(Long value) {
            addCriterion("NOW_PAYABLE_BEFORE =", value);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeNotEqualTo(Long value) {
            addCriterion("NOW_PAYABLE_BEFORE <>", value);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeGreaterThan(Long value) {
            addCriterion("NOW_PAYABLE_BEFORE >", value);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeGreaterThanOrEqualTo(Long value) {
            addCriterion("NOW_PAYABLE_BEFORE >=", value);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeLessThan(Long value) {
            addCriterion("NOW_PAYABLE_BEFORE <", value);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeLessThanOrEqualTo(Long value) {
            addCriterion("NOW_PAYABLE_BEFORE <=", value);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeIn(List<Long> values) {
            addCriterion("NOW_PAYABLE_BEFORE in", values);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeNotIn(List<Long> values) {
            addCriterion("NOW_PAYABLE_BEFORE not in", values);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeBetween(Long value1, Long value2) {
            addCriterion("NOW_PAYABLE_BEFORE between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andNowPayableBeforeNotBetween(Long value1, Long value2) {
            addCriterion("NOW_PAYABLE_BEFORE not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andParentIdIsNull() {
            addCriterion("PARENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andParentIdIsNotNull() {
            addCriterion("PARENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andParentIdEqualTo(String value) {
            addCriterion("PARENT_ID =", value);
            return (Criteria) this;
        }

        public Criteria andParentIdNotEqualTo(String value) {
            addCriterion("PARENT_ID <>", value);
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThan(String value) {
            addCriterion("PARENT_ID >", value);
            return (Criteria) this;
        }

        public Criteria andParentIdGreaterThanOrEqualTo(String value) {
            addCriterion("PARENT_ID >=", value);
            return (Criteria) this;
        }

        public Criteria andParentIdLessThan(String value) {
            addCriterion("PARENT_ID <", value);
            return (Criteria) this;
        }

        public Criteria andParentIdLessThanOrEqualTo(String value) {
            addCriterion("PARENT_ID <=", value);
            return (Criteria) this;
        }

        public Criteria andParentIdLike(String value) {
            addCriterion("PARENT_ID like", value);
            return (Criteria) this;
        }

        public Criteria andParentIdNotLike(String value) {
            addCriterion("PARENT_ID not like", value);
            return (Criteria) this;
        }

        public Criteria andParentIdIn(List<String> values) {
            addCriterion("PARENT_ID in", values);
            return (Criteria) this;
        }

        public Criteria andParentIdNotIn(List<String> values) {
            addCriterion("PARENT_ID not in", values);
            return (Criteria) this;
        }

        public Criteria andParentIdBetween(String value1, String value2) {
            addCriterion("PARENT_ID between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andParentIdNotBetween(String value1, String value2) {
            addCriterion("PARENT_ID not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAddByIsNull() {
            addCriterion("ADD_BY is null");
            return (Criteria) this;
        }

        public Criteria andAddByIsNotNull() {
            addCriterion("ADD_BY is not null");
            return (Criteria) this;
        }

        public Criteria andAddByEqualTo(String value) {
            addCriterion("ADD_BY =", value);
            return (Criteria) this;
        }

        public Criteria andAddByNotEqualTo(String value) {
            addCriterion("ADD_BY <>", value);
            return (Criteria) this;
        }

        public Criteria andAddByGreaterThan(String value) {
            addCriterion("ADD_BY >", value);
            return (Criteria) this;
        }

        public Criteria andAddByGreaterThanOrEqualTo(String value) {
            addCriterion("ADD_BY >=", value);
            return (Criteria) this;
        }

        public Criteria andAddByLessThan(String value) {
            addCriterion("ADD_BY <", value);
            return (Criteria) this;
        }

        public Criteria andAddByLessThanOrEqualTo(String value) {
            addCriterion("ADD_BY <=", value);
            return (Criteria) this;
        }

        public Criteria andAddByLike(String value) {
            addCriterion("ADD_BY like", value);
            return (Criteria) this;
        }

        public Criteria andAddByNotLike(String value) {
            addCriterion("ADD_BY not like", value);
            return (Criteria) this;
        }

        public Criteria andAddByIn(List<String> values) {
            addCriterion("ADD_BY in", values);
            return (Criteria) this;
        }

        public Criteria andAddByNotIn(List<String> values) {
            addCriterion("ADD_BY not in", values);
            return (Criteria) this;
        }

        public Criteria andAddByBetween(String value1, String value2) {
            addCriterion("ADD_BY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAddByNotBetween(String value1, String value2) {
            addCriterion("ADD_BY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNull() {
            addCriterion("ADD_TIME is null");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNotNull() {
            addCriterion("ADD_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andAddTimeEqualTo(Date value) {
            addCriterion("ADD_TIME =", value);
            return (Criteria) this;
        }

        public Criteria andAddTimeNotEqualTo(Date value) {
            addCriterion("ADD_TIME <>", value);
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThan(Date value) {
            addCriterion("ADD_TIME >", value);
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ADD_TIME >=", value);
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThan(Date value) {
            addCriterion("ADD_TIME <", value);
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThanOrEqualTo(Date value) {
            addCriterion("ADD_TIME <=", value);
            return (Criteria) this;
        }

        public Criteria andAddTimeIn(List<Date> values) {
            addCriterion("ADD_TIME in", values);
            return (Criteria) this;
        }

        public Criteria andAddTimeNotIn(List<Date> values) {
            addCriterion("ADD_TIME not in", values);
            return (Criteria) this;
        }

        public Criteria andAddTimeBetween(Date value1, Date value2) {
            addCriterion("ADD_TIME between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andAddTimeNotBetween(Date value1, Date value2) {
            addCriterion("ADD_TIME not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andUptByIsNull() {
            addCriterion("UPT_BY is null");
            return (Criteria) this;
        }

        public Criteria andUptByIsNotNull() {
            addCriterion("UPT_BY is not null");
            return (Criteria) this;
        }

        public Criteria andUptByEqualTo(String value) {
            addCriterion("UPT_BY =", value);
            return (Criteria) this;
        }

        public Criteria andUptByNotEqualTo(String value) {
            addCriterion("UPT_BY <>", value);
            return (Criteria) this;
        }

        public Criteria andUptByGreaterThan(String value) {
            addCriterion("UPT_BY >", value);
            return (Criteria) this;
        }

        public Criteria andUptByGreaterThanOrEqualTo(String value) {
            addCriterion("UPT_BY >=", value);
            return (Criteria) this;
        }

        public Criteria andUptByLessThan(String value) {
            addCriterion("UPT_BY <", value);
            return (Criteria) this;
        }

        public Criteria andUptByLessThanOrEqualTo(String value) {
            addCriterion("UPT_BY <=", value);
            return (Criteria) this;
        }

        public Criteria andUptByLike(String value) {
            addCriterion("UPT_BY like", value);
            return (Criteria) this;
        }

        public Criteria andUptByNotLike(String value) {
            addCriterion("UPT_BY not like", value);
            return (Criteria) this;
        }

        public Criteria andUptByIn(List<String> values) {
            addCriterion("UPT_BY in", values);
            return (Criteria) this;
        }

        public Criteria andUptByNotIn(List<String> values) {
            addCriterion("UPT_BY not in", values);
            return (Criteria) this;
        }

        public Criteria andUptByBetween(String value1, String value2) {
            addCriterion("UPT_BY between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andUptByNotBetween(String value1, String value2) {
            addCriterion("UPT_BY not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andUptTimeIsNull() {
            addCriterion("UPT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUptTimeIsNotNull() {
            addCriterion("UPT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUptTimeEqualTo(Date value) {
            addCriterion("UPT_TIME =", value);
            return (Criteria) this;
        }

        public Criteria andUptTimeNotEqualTo(Date value) {
            addCriterion("UPT_TIME <>", value);
            return (Criteria) this;
        }

        public Criteria andUptTimeGreaterThan(Date value) {
            addCriterion("UPT_TIME >", value);
            return (Criteria) this;
        }

        public Criteria andUptTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPT_TIME >=", value);
            return (Criteria) this;
        }

        public Criteria andUptTimeLessThan(Date value) {
            addCriterion("UPT_TIME <", value);
            return (Criteria) this;
        }

        public Criteria andUptTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPT_TIME <=", value);
            return (Criteria) this;
        }

        public Criteria andUptTimeIn(List<Date> values) {
            addCriterion("UPT_TIME in", values);
            return (Criteria) this;
        }

        public Criteria andUptTimeNotIn(List<Date> values) {
            addCriterion("UPT_TIME not in", values);
            return (Criteria) this;
        }

        public Criteria andUptTimeBetween(Date value1, Date value2) {
            addCriterion("UPT_TIME between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andUptTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPT_TIME not between", value1, value2);
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}